SUPPORT / SAMPLES & SAS NOTES
Problem Note 54418: SAS® Customer Experience Analytics CXA_ETL job returns "ORACLE execute error: ORA-01400: cannot insert NULL..."
 |  |  |  |  |
If there is no internal search data to be loaded, then the CXA_ETL job for SAS Customer Experience Analytics fails to complete. When this problem occurs, the CXA_ETL job returns the following error:
ORACLE execute error: ORA-01400: cannot insert NULL into ("OLMCXA"."SEARCH_RESULTS"."SEARCH_RESULTS_SK")
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Experience Analytics | 64-bit Enabled Solaris | 6.1 | 6.3 | 9.4 TS1M0 | |
| 64-bit Enabled AIX | 6.1 | 6.3 | 9.4 TS1M0 | |||
| Microsoft® Windows® for x64 | 6.1 | 6.3 | 9.4 TS1M0 | |||
| Linux for x64 | 6.1 | 6.3 | 9.4 TS1M0 | |||
| Solaris for x64 | 6.1 | 6.3 | 9.4 TS1M0 | |||